If column B can have nulls, try SELECT A, COALESCE(SUM(B),0) AS total FROM table GROUP BY A.
– JoshRoss Apr 2 at 3:30 @JoshRoss check out talideon. Com/weblog/2007/09/sum-coalesce. Cfm – Bala R Apr 2 at 3:34 THanks, but I did try that already.
As well as the ISNULL.. My guess is the C# SqlDataReader bit is to blame for reading the 0 as a NULL road – Raskaroth Apr 2 at 10:21.
Or try to edit the line: total += total_reader"A".ToString() + " " + total_reader"total" + "\n"; to total += total_reader"A".ToString() + " " + int. Parse(total_reader"total".ToString()) + "\n.
Okay turns out that I had WHERE (B = 1) I forgot to take this out of my SQL querry.. Thanks for the help :).
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.